Custom Document - Insert Merge Fields:
Case People section

 

FIELD NAME

DEFINITION

WHERE TO FIND IN MIS PROFESSIONAL

AuthAgent_Address

Address of the Authorizing Agent case person

Example: 33 North Main St

Case People & Relationships Screen
AuthAgent_Area_Code

Area code of the Authorizing Agent case person

Example: 603

Case People & Relationships Screen
AuthAgent_City

City of the Authorizing Agent case person

Example: Manchester

Case People & Relationships Screen
AuthAgent_Different_Mail_Addr If any of the fields MailingStreetAddress /MailingCity /MailingState/MailingZip is populated this flag is set as 1. The value can be same as primary address Name Maintenance Screen for the Authorizing Agent
AuthAgent_Email

Email address of the Authorizing Agent case person

Example: [email protected]

Case People & Relationships Screen
AuthAgent_First_Name

First Name of the Authorizing Agent case person

Example: Joe Smith

Case People & Relationships Screen
AuthAgent_FML

First, Middle and Last name of the Authorizing Agent case person

Example: Joe M Smith

Case People & Relationships Screen
AuthAgent_FullSuffixName

Full suffixed name of the Authorizing Agent case person

Example: Joe M Smith, Jr.

Case People & Relationships Screen
AuthAgent_Last_Name

Last Name of the Authorizing Agent case person

Example: Smith

Case People & Relationships Screen
AuthAgent_MailingCity

The Authorizing Agent's Mailing City

Example: Batesville

Case People & Relationships Screen
AuthAgent_MailingState

The Authorizing Agent's Mailing State

Example: NH

Case People & Relationships Screen
AuthAgent_MailingStateDescr

The Authorizing Agent's Mailing State

Example: New Hampshire

Case People & Relationships Screen
AuthAgent_MailingStreetAddress

The Authorizing Agent's Mailing Street Address

Example: 123 Main Streets

Case People & Relationships Screen
AuthAgent_Mailing_Zip

The Authorizing Agent's Mailing Zip

Example: 03045

Case People & Relationships Screen
AuthAgent_Mailing_Salutation

Mailing salutation of the Authorizing Agent

Example Mr. Joe Smith

Case People & Relationships Screen
AuthAgent_Middle_Name

Middle name of the Authorizing Agent case person

Example: M

Case People & Relationships Screen
AuthAgent_Phone

Phone number of the Authorizing Agent case person

Example: 603-888-1234

Case People & Relationships Screen
AuthAgent_Phone_Last_7

Last 7 digits of the Authorizing Agent’s phone number

Example: 888-1234

Case People & Relationships Screen
AuthAgent_Primary_Prefix

Prefix of the Authorizing Agent's name

Exampe: Mr

Case People & Relationships Screen
AuthAgent_State

State of the Authorizing Agent case person

Example: NH

Case People & Relationships Screen
AuthAgent_State_Descr

Full State description of the Authorizing Agent case person

Example: New Hampshire

Case People & Relationships Screen
AuthAgent_Zip

Zip Code of the Authorizing Agent case person

Example: 03101

Case People & Relationships Screen

Beneficiary_Address

The address of beneficiary on the case.

Example: 1 Hemlock Road

Case People & Relationships Screen

Beneficiary_Age

The age of beneficiary on the case.

Case People & Relationships Screen

Beneficiary_Area_Code

The area code of beneficiary on the case.

Example: 603

Case People & Relationships Screen

Beneficiary_Birth_Date

The birth date of beneficiary on the case.

Case People & Relationships Screen

Beneficiary_Birth_Date_Search

The birth date of beneficiary on the case.

Case People & Relationships Screen

Beneficiary_City

The city of beneficiary on the case.

Example: Goffstown

Case People & Relationships Screen

Beneficiary_CSZ

The city, state and zip code of beneficiary on the case.

Example: Goffstown, NH 03045

Case People & Relationships Screen
Beneficiary_Different_Mail_Addr If any of the fields MailingStreetAddress /MailingCity /MailingState/MailingZip has non null value this flag would be set as 1. The value can be same as primary address. This behavior is in consistent with MIS Pro name maintenance Case People & Relationships Screen

Beneficiary_EMail

The email ID of beneficiary on the case.

 

Case People & Relationships Screen

Beneficiary_First_Name

The first name of beneficiary on the case.

Example: Sam

Case People & Relationships Screen

Beneficiary_FML

The name of beneficiary on the case.

Example: Mrs. Sam Malory

Case People & Relationships Screen

Beneficiary_FullSuffixName

The name of beneficiary on the case.

Example: Sam Malory

Case People & Relationships Screen

Beneficiary_Last_Name

The last name of beneficiaryon the case.

Example: Malory

Case People & Relationships Screen

Beneficiary_Mailing_Salutation

The salutation of the beneficiary on the case.

Example: Mrs. Malory

Case People & Relationships Screen
Beneficiary_MailingCity

The beneficiary's mailing city.

Example: Batesville

Case People & Relationships Screen
Beneficiary_MailingState

The beneficiary's mailing state.

Example: NH

Case People & Relationships Screen
Beneficiary_MailingStateDescr

The beneficiary's mailing state.

Example: New Hampshire

Case People & Relationships Screen
Beneficiary_MailingStreetAddress

The beneficiary's mailing street address.

Example: 123 Main Street

Case People & Relationships Screen
Beneficiary_MailingZIP

The beneficiary's mailing zip.

Example: 03045

Case People & Relationships Screen

Beneficiary_Middle_Name

The middle name of beneficiaryon the case.

Case People & Relationships Screen

Beneficiary_Phone

The phone number with area code of beneficiary on the case.

Example: (603) 555-5555

Case People & Relationships Screen

Beneficiary_Phone_Last_7

The phone number without area code of beneficiary on the case.

Example: 555-5555

Case People & Relationships Screen

Beneficiary_Primary_Prefix

The prefix part of beneficiary on the case.

Example: Mrs.          

Case People & Relationships Screen

Beneficiary_SSN_Parsed

The social security number of beneficiary on the case.

Case People & Relationships Screen

Beneficiary_State

The state of beneficiary on the case.

Example: NH       

Case People & Relationships Screen

Beneficiary_State_Descr

The state of beneficiary on the case.

Example: New Hampshire                

Case People & Relationships Screen

Beneficiary_Zip

The zip code of beneficiary on the case.

Example: 03045

Case People & Relationships Screen

CasePerson (1 to 10)

The name of the case person (up to 10).

These names are in the Case People section of the Case People and Relationships screen.

NOTE: These 10 names will NOT include the following as these are separately available in the data source:

NOK, ARRANGER, FATHER, MOTHER, SPOUSE

Case People & Relationships Screen

CasePersonRelationship
(1 to 10)

The relationship of the name to the deceased (up to 10).

These names are in the Case People section of the Case People and Relationships screen.

NOTE: These 10 names will NOT include the following as these are separately available in the data source: NOK, ARRANGER, FATHER, MOTHER, SPOUSE

Case People & Relationships Screen

Child1 to 5

The name of children of the decedent on the case. (Up to 5)

These are names in the Relationships section of the screen that have a relationship of SON or DAUGHTER.

Example: Denise Winston

Case People & Relationships Screen

DeceasedsFather

The father name of decedent on the case.

Example: Mr. William  Malory

Case People & Relationships Screen

DeceasedsMother

The name of deceased mother on the case.  (Mothers are case people.)

Example: Jane  Hawthorne

Case People & Relationships Screen
EmbalmAuth_Different_Mail_Addr If any of the fields MailingStreetAddress /MailingCity /MailingState/MailingZip has non null value this flag would be set as 1. The value can be same as primary address. This behavior is in consistent with MIS Pro name maintenance Case People & Relationships Screen
EmbalmAuth_MailingCity

The Embalming Authorizers Mailing City.

Example: Batesville

Case People & Relationships Screen
EmbalmAuth_MailingState

The Embalming Authorizers Mailing State.

Example: NH

Case People & Relationships Screen
EmbalmAuth_MailingStateDescr

The Embalming Authorizers Mailing State.

Example: New Hampshire

Case People & Relationships Screen
EmbalmAuth_MailingStreetAddress

The Embalming Authorizers Mailing Street Address.

Example: 123 Main Street

Case People & Relationships Screen
EmbalmAuth_Mailing_Zip

The Embalming Authorizers Mailing Zip.

Example: 03054

Case People & Relationships Screen

Family1 (thru 35)

The name of family members of the decedent on the case. (Up to 35)

These are names in the Relationships section of the screen that have a relationship that is flagged as “family”. By default, “family” includes the following relationships:

Brother                      

Child

Daughter                     

Grand Daughter

Grand Son

Sister                       

Son                          

Step Brother

Step Daughter

Step Father

Step Mother

Step Sister

Step Son

 

If you want to include other relationships as “family”; check the family flag in Relationship Code Maintenance.

Case People & Relationships Screen

Family1_Relationship (thru 35)

The relationship of the family member to the deceased.

Case People & Relationships Screen

FamilyContact

The name of the “Arranger” case person on the case.

Example: Karen Schuler

Case People & Relationships Screen

FamilyContactFullAddress

The address of the “Arranger” case person on the case.

Example: 50 Oak Street Manchester, NH 03102

Case People & Relationships Screen

Father_Name

The name of the decedent's Father on the case.

Example: Mike Jones

Case People & Relationships Screen
FatherBirthPlaceCity

City where decedent's father was born

Example: Tampa

Case People & Relationships Screen
FatherBirthStateCd

State code where decedent’s father was born

Example: Florida

Case People & Relationships Screen

ImmediateFamily_Children1
(thru 10)

The name of son(s) and or daughter(s) associated with the decedent. (Up to 10)

These are names in the Relationships section of the screen that have a relationship of SON or DAUGHTER.

Example: Denise Winston   

Case People & Relationships Screen

ImmediateFamily_GrandChildren1 to 20

The name of immediate family grand children associated with the decedent. (Up to 20)

These are names in the Relationships section of the screen that have a relationship of Grand Daughter or Grand Son.

Example: Betty Malory

Case People & Relationships Screen

ImmediateFamily_GrandParents1 to 10

The name of immediate family grand parents associated with the decedent. (Up to 10)

These are names in the Relationships section of the screen that have a relationship of Grand Parent, Grand Mother or Grand Father.

 

Case People & Relationships Screen

Informant_Different_Mail_Addr If any of the fields MailingStreetAddress /MailingCity /MailingState/MailingZip has non null value this flag would be set as 1. The value can be same as primary address. This behavior is in consistent with MIS Pro name maintenance Case People & Relationships Screen
Informant_MailingCity

Informant's Mailing City.

Example: Batesville

Case People & Relationships Screen
Informant_MailingState

Informant's Mailing City.

Example: NH

Case People & Relationships Screen
Informant_MailingStateDescr

Informant's Mailing State.

Example: New Hampshire

Case People & Relationships Screen
Informant_MailingStreetAddress

Informant's Mailing Street Address.

Example: 123 Main Street

Case People & Relationships Screen
Informant_Mailing_Zip

Informant's Mailing Zip.

Example: 03045

Case People & Relationships Screen

Informant_Mailing_Salutation

The Informant’s Mailing Salutation on the case. Informants are case people.

Example: Mrs. Malory

Case People & Relationships Screen

Informant_phone

The informant’s phone on the case. Informants are case people.

Example: (603) 555-5555

Case People & Relationships Screen

Informant_Primary_Prefix

The prefix part of the informant’s name on the case. Informants are case people.

Example: Mrs.          

Case People & Relationships Screen

InformantCity

The informant’s address on the case. Informants are case people.

Example: Goffstown

Case People & Relationships Screen

InformantCSZ

The informant’s city, state and zip code on the case. Informants are case people.

Example: Goffstown, NH 03045

Case People & Relationships Screen
InformantEmail

The informant's email address

Example: [email protected]

Case People & Relationships Screen

InformantFirstName

The informant’s first name on the case. Informants are case people.

Example: Sam

Case People & Relationships Screen

InformantFullSuffixName

The informant’s name with the suffix on the case. Informants are case people.

Example: Sam Malory

Case People & Relationships Screen

InformantLastName

The Informant’s Last name on the case. Informants are case people.

Example: Malory

Case People & Relationships Screen

InformantMiddleName

The informant’s Middle name on the case. Informants are case people.

Case People & Relationships Screen

InformantPrimaryFullAddress

The informant’s address on the case. Informants are case people.

Example: 1 Hemlock Road Goffstown, NH 03045

Case People & Relationships Screen

InformantRelationship

The informant’s relationship on the case. Informants are case people.

Example: Daughter                     

Case People & Relationships Screen

InformantStateCd

The informant’s state on the case. Informants are case people.

Example: NH       

Case People & Relationships Screen

InformantStateName

The informant’s state on the case. Informants are case people.

Example: New Hampshire                

Case People & Relationships Screen

InformantStreet

The informant’s address on the case. Informants are case people.

Example: 1 Hemlock Road

Case People & Relationships Screen

InformantSubTitle

The informant’s sub title on the case. Informants are case people.

Case People & Relationships Screen

InformantZip

The informant’s zip code on the case. Informants are case people.

Example: 03045

Case People & Relationships Screen

Mother_Name

The maiden name of decedent mother on the case.

Example: Jane  Hawthorne

Case People & Relationships Screen
MotherBirthPlaceCity

City where decedent's mother was born

Example: Tampa

Case People & Relationships Screen
MotherBirthStateCd

State code where decedent’s mother was born

Example: Florida

Case People & Relationships Screen

Mothers_Maiden_Name

The maiden name of decedent mother on the case.

Example: Jane  Hawthorne Malory

Case People & Relationships Screen
NOK_Different_Mail_Addr If any of the fields MailingStreetAddress /MailingCity /MailingState/MailingZip has non null value this flag would be set as 1. The value can be same as primary address. This behavior is in consistent with MIS Pro name maintenance. Case People & Relationships Screen
NOK_MailingCity

Next of Kin's Mailing City.

Example: Batesville

Case People & Relationships Screen
NOK_MailingState

Next of Kin's Mailing State.

Example: NH

Case People & Relationships Screen
NOK_MailingStateDescr

Next of Kin's Mailing State.

Example: New Hampshire

Case People & Relationships Screen
NOK_MailingStreetAddress

Next of Kin's Mailing Street Adress.

Example: 123 Main Street

Case People & Relationships Screen
NOK_Mailing_Zip

Next of Kin's Mailing Zip.

Example: 03054

Case People & Relationships Screen

NOK_Mailing_Salutation

The mailing salutation of Next of Kin of the decedent on the case. Next of Kin names are case people.

Example: Benjamin Malory

Case People & Relationships Screen

NOK_phone

The phone number of Next of Kin of the decedent on the case.

Next of Kin names are case people.

Example: (603) 555-4444

Case People & Relationships Screen

NOK_Primary_Prefix

The prefix part of Next of Kin of the decedent on the case. Next of Kin names are case people.

Example: Mr.           

Case People & Relationships Screen

NOKCity

The city of Next of Kin of the decedent on the case. Next of Kin names are case people.

Example: Manchester

Case People & Relationships Screen

NOKCSZ

The city, state and zip of Next of Kin of the decedent on the case. Next of Kin names are case people.

Example: Manchester, NH 03102

Case People & Relationships Screen

NOKFirstName

The first name of Next of Kin of the decedent on the case. Next of Ken names are case people.

Example: Benjamin

Case People & Relationships Screen

NOKFullSuffixName

The full suffix name of Next of Kin of the decedent on the case. Next of Ken names are case people.

Example: Benjamin R Malory Jr.

Case People & Relationships Screen

NOKLastName

The last name of Next of Kin of the decedent on the case. Next of Ken names are case people.

Example: Malory

Case People & Relationships Screen

NOKMiddleName

The middle name of Next of Kin of the decedent on the case. Next of Ken names are case people.

Example: R

Case People & Relationships Screen

NOKPrimaryFullAddress

The full address of Next of Kin of the decedent on the case. Next of Kin names are case people.

Example: 40 Turning Leaf Road Manchester, NH 03102

Case People & Relationships Screen

NOKRelationship

The relationship of Next of Kin with the decedent on the case. Next of Kin names are case people.

Example: Spouse                       

Case People & Relationships Screen

NOKStateCd

The state of Next of Kin of the decedent on the case. Next of Kin names are case people.

Example: NH       

Case People & Relationships Screen

NOKStateName

The state of Next of Kin of the decedent on the case. Next of Kin names are case people.

Example: New Hampshire                

Case People & Relationships Screen

NOKStreet

The street of Next of Kin of the decedent on the case. Next of Kin names are case people.

Example: 40 Turning Leaf Road

Case People & Relationships Screen

NOKSubTitle

The suffix part of Next of Kin of the decedent on the case. Next of Ken names are case people.

Example: Jr.

Case People & Relationships Screen

NOKZip

The zip code of Next of Kin of the decedent on the case. Next of Kin names are case people.

Example: 03102

Case People & Relationships Screen

PrecededInDeath1-10

Family members that are preceded in death.

These are names in the Relationships section of the screen that have the “preceded in death” box checked.

Case People & Relationships Screen
PrecededList Lists ALL names in the Relationships section of the screen that have the “preceded in death” box checked. Case People & Relationships Screen

Purchaser_Address

The address of purchaser on the case.

Example: 40 Turning Leaf Road

Case People & Relationships Screen

Purchaser_Area_Code

The area code of purchaser on the case.

Example: 603

Case People & Relationships Screen

Purchaser_City

The city of purchaser on the case.

Example: Manchester

Case People & Relationships Screen

Purchaser_EMail

The email ID of the purchaser on the case.

Example: [email protected]                                                                    

Case People & Relationships Screen

Purchaser_First_Name

The first name of purchaser on the case.

Example: Benjamin

Case People & Relationships Screen

Purchaser_FML

The name of purchaser on the case.

Example: Mr. Benjamin R Malory Jr.

Case People & Relationships Screen

Purchaser_FullSuffixName

The name of purchaser on the case.

Example: Benjamin R Malory Jr.

Case People & Relationships Screen

Purchaser_Last_Name

The last name of purchaser on the case.

Example: Malory

Case People & Relationships Screen
Purchaser_Different_Mail_Addr If any of the fields MailingStreetAddress /MailingCity /MailingState/MailingZip has non null value this flag would be set as 1. The value can be same as primary address. This behavior is in consistent with MIS Pro name maintenance Case People & Relationships Screen
Purchaser_MailingCity

Purchaser's Mailing City.

Example: Batesville

Case People & Relationships Screen
Purchaser_MailingState

Purchaser's Mailing State.

Example: NH

Case People & Relationships Screen
Purchaser_MailingStateDescr

Purchaser's Mailing State.

Example: New Hampshire

Case People & Relationships Screen
Purchaser_MailingStreetAddress

Purchaser's Mailing Street Address.

Example: 123 Main Street

Case People & Relationships Screen
Purchaser_Mailing_Zip

Purchaser's Mailing Zip.

Example: 03054

Case People & Relationships Screen

Purchaser_Mailing_Salutation

The salutation of the purchaser on the case.

Example: Benjamin Malory

Case People & Relationships Screen

Purchaser_Middle_Name

The middle name of purchaser on the case.

Example: R

Case People & Relationships Screen

Purchaser_Phone

The phone number with area code of purchaser on the case.

Example: (603) 555-4444

Case People & Relationships Screen

Purchaser_Phone_Last_7

The phone number without area code of purchaser on the case.

Example: 555-4444

Case People & Relationships Screen

Purchaser_Primary_Prefix

The prefix part of purchaser on the case.

Example: Mr.           

Case People & Relationships Screen

Purchaser_State

The state of purchaser on the case.

Example: NH       

Case People & Relationships Screen

Purchaser_State_Descr

The state of purchaser on the case.

Example: New Hampshire                

Case People & Relationships Screen

Purchaser_Zip

The zip code of purchaser on the case.

Example: 03102

Case People & Relationships Screen

Sibling1 to 10

The name of sibling(s) associated with the decedent. (Up to 10)

These are names in the Relationships section of the screen that have a relationship of BROTHER or SISTER.

Example: Peter Mallory

Case People & Relationships Screen

Spouse

The name of deceased spouse on the case.  (Spouses are case people)

Example: Mr. Benjamin R Malory Jr.

Case People & Relationships Screen
Spouse_Address

The address of the deceased's spouse

Example: 22 Main St

Case People & Relationships Screen
Spouse_Area_Code

The area code of the spouse's phone number

Example: 603

Case People & Relationships Screen
Spouse_City

The City of the spouse's address

Example: Bedford

Case People & Relationships Screen

Spouse_Death_Date

Spouse’s Death Date

Example: 1-Jul-14

Case People & Relationships Screen

Spouse_Death_Date_Search

Spouse’s Death Date

Example: 7/1/2014  12:00:00 AM

Case People & Relationships Screen

Spouse_Death_Day

Spouse’s Day of Death

Example: Monday

Case People & Relationships Screen

Spouse_Death_Time

Spouse’s Death Time

Example: 2:14pm

Case People & Relationships Screen

Spouse_Deceased

Whether or not spouse is deceased

Example: yes

Case People & Relationships Screen
Spouse_Different_Mail_Addr If any of the fields MailingStreetAddress /MailingCity /MailingState/MailingZip has non null value this flag would be set as 1. The value can be same as primary address. This behavior is in consistent with MIS Pro name maintenance Case People & Relationships Screen
Spouse_Email

Email address of the spouse on the case

Example: [email protected]

Case People & Relationships Screen

Spouse_First_Name

The first name of the spouse on the case.

Example: Benjamin

Case People & Relationships Screen
Spouse_FML

First, Middle and Last name of the spouse on the case

Example: Jane M Jones

Case People & Relationships Screen

Spouse_Full_Name

Full name of spouse of decedent

Example: Mr. Benjamin R Malory Jr

Case People & Relationships Screen

Spouse_FullSuffixName

The name of spouse on the case without the prefix.

Example: Benjamin R Malory Jr. 

Case People & Relationships Screen

Spouse_Last_Name

The last name of the spouse on the case.

Example: Malory

Case People & Relationships Screen

Spouse_Maiden_Name

The maiden name spouse on the case.

Case People & Relationships Screen
Spouse_Mailing_Salutation

Mailing Salutation for the spouse on the case.

Example: Mrs. Jane Jones

Case People & Relationships Screen
Spouse_MailingCity

Spouse's Mailing City.

Example: Batesville

Case People & Relationships Screen
Spouse_MailingState

Spouse's Mailing State.

Example: NH

Case People & Relationships Screen
Spouse_MailingStateDescr

Spouse's Mailing State.

Example: New Hampshire

Case People & Relationships Screen
Spouse_MailingStreetAddress

Spouse's Mailing Street Address.

Example: 123 Main Street

Case People & Relationships Screen
Spouse_Mailing_Zip

Spouse's Mailing Zip.

Example: 03054

Case People & Relationships Screen

Spouse_Middle_Name

The middle name of the spouse on the case.

Example: R

Case People & Relationships Screen
Spouse_Phone

The phone number of the spouse on the case

Example: 603-555-7777

Case People & Relationships Screen
Spouse_Phone_Last_7

The last 7 digits of the phone number for the spouse on the case

Example: 555-7777

Case People & Relationships Screen
Spouse_Primary_Prefix

The prefix of the name of the spouse on the case

Example: Mrs.

Case People & Relationships Screen

Spouse_Relation

The relationship with the decedent

Example: Spouse

Case People & Relationships Screen
Spouse_State

The state of the address of the spouse on the case

Example: NH

Case People & Relationships Screen
Spouse_State_Descr

The full description of the state of the address of the spouse on the case

Example: New Hampshire

Case People & Relationships Screen

Spouse_Suffix

The name suffix of spouse on the case.

Example: Jr.

Case People & Relationships Screen

Spouse_Title

The prefix part of the name of spouse

Example: Mr. 

Case People & Relationships Screen
Spouse_Zip

The zip code of the address of the spouse on the case

Example: 03101

Case People & Relationships Screen
SurvivedBy1-10 Family members listed in the Relationships section of the screen that do not have the “preceded in death” box checked. Case People & Relationships Screen
SurvivorList Lists ALL names in the Relationships section of the screen that do not have the “preceded in death” box checked. Case People & Relationships Screen